if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sodor_Ghest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Sodor_Ghest]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Create_Sanad_Ghest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Create_Sanad_Ghest]



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TU_Ghest]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TU_Ghest]